WEEKDAY

Returns the day of the week for a given date.

Syntax

WEEKDAY(date, [return_type])

Arguments

• date: The date for which you want to find the day of the week.
• return_type: [Optional] A number that determines the return value format.
  • 1 or omitted: Numbers 1 (Sunday) through 7 (Saturday)
  • 2: Numbers 1 (Monday) through 7 (Sunday)
  • 3: Numbers 0 (Monday) through 6 (Sunday)

Example

WEEKDAY("2025-03-02", 1) → Returns 1 (Sunday)
WEEKDAY(A1, 2) → Returns the weekday number for the date in cell A1 using Monday as day 1